How to: Create a custom AutoFill list from an existing list.
Solution:
Select the cells containing the list and select 'Options...' from the 'Tools' menu. Click the 'Custom Lists' tab and import the list.
1) Select the cells containing the list to be used as a series on the worksheet.
2) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
3) Click the 'Custom Lists' tab.
NOTE: The references for the selected cells appear in the 'Import List from Cells' box.
the Import List from Cells box
4) Click 'Import'. (The content of the selected cells appears in the Custom Lists and the List Entries list boxes.)
Importing the list
5) Click 'OK'.
